package com.example.utgardtutorial1.mapper;

import com.example.utgardtutorial1.entity.Zhsc1;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author wwc
 * @since 2023-10-23
 */
public interface Zhsc1Mapper extends BaseMapper<Zhsc1> {

    @Select("select concat('JBSC.',COLUMN_NAME) from zhsc1_name")
    List<String> selectOpcItems();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'zhsc1' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsOne();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'clsn_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsClsn();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'cp200' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsCp200();
    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'cp300' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsCp300();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'cp320' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsCp320();
    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'cp500' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsCp500();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'lsa_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsLsa();
    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'opc_phase2' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsOpcPhase2();
    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'other_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsOther();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'ssbf_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsSsbf();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'tjs_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsTjs();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'wn_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsWn();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'ysbf_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsYsbf();

    @Select("select concat('JBSC.',t.COLUMN_NAME) from simulation_save_name_one as a,information_schema.COLUMNS as t " +
            "where table_name = 'ysbz_opc' and a.COLUMN_NAME = t.COLUMN_NAME")
    List<String> selectSimulationItemsYsbz();
    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'zhsc1' ")
    List<String> selectOnlyOpcItems();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'clsn_opc' ")
    List<String> selectOnlyOpcItemsClsn();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'cp200' ")
    List<String> selectOnlyOpcItemsCp200();
    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'cp300' ")
    List<String> selectOnlyOpcItemsCp300();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'cp320' ")
    List<String> selectOnlyOpcItemsCp320();
    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'cp500' ")
    List<String> selectOnlyOpcItemsCp500();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'lsa_opc' ")
    List<String> selectOnlyOpcItemsLsa();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'opc_phase2' ")
    List<String> selectOnlyOpcItemsOpcPhase2();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'other_opc' ")
    List<String> selectOnlyOpcItemsOther();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'ssbf_opc' ")
    List<String> selectOnlyOpcItemsSsbf();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'tjs_opc' ")
    List<String> selectOnlyOpcItemsTjs();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'wn_opc' ")
    List<String> selectOnlyOpcItemsWn();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'ysbf_opc' ")
    List<String> selectOnlyOpcItemsYsbf();

    @Select("select concat('JBSC.',COLUMN_NAME) from information_schema.COLUMNS where table_name = 'ysbz_opc' ")
    List<String> selectOnlyOpcItemsYsbz();
}
